Overview

Brought to you by YData

Dataset statistics

Number of variables	21
Number of observations	2256
Missing cells	12610
Missing cells (%)	26.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	808.1 KiB
Average record size in memory	366.8 B

Variable types

DateTime	2
Numeric	14
Text	1
Categorical	2
Unsupported	2

Alerts

`city_name` has constant value "local"	Constant
`Autoconsumo (kWh)` is highly overall correlated with `Horário Económico (kWh)`	High correlation
`Hora` is highly overall correlated with `Normal (kWh)`	High correlation
`Horário Económico (kWh)` is highly overall correlated with `Autoconsumo (kWh)` and 1 other fields	High correlation
`Normal (kWh)` is highly overall correlated with `Hora` and 1 other fields	High correlation
`clouds_all` is highly overall correlated with `humidity` and 1 other fields	High correlation
`feels_like` is highly overall correlated with `temp` and 2 other fields	High correlation
`humidity` is highly overall correlated with `clouds_all`	High correlation
`rain_1h` is highly overall correlated with `weather_description`	High correlation
`temp` is highly overall correlated with `feels_like` and 2 other fields	High correlation
`temp_max` is highly overall correlated with `feels_like` and 2 other fields	High correlation
`temp_min` is highly overall correlated with `feels_like` and 2 other fields	High correlation
`weather_description` is highly overall correlated with `clouds_all` and 1 other fields	High correlation
`dt` has 504 (22.3%) missing values	Missing
`dt_iso` has 504 (22.3%) missing values	Missing
`city_name` has 504 (22.3%) missing values	Missing
`temp` has 504 (22.3%) missing values	Missing
`feels_like` has 504 (22.3%) missing values	Missing
`temp_min` has 504 (22.3%) missing values	Missing
`temp_max` has 504 (22.3%) missing values	Missing
`pressure` has 504 (22.3%) missing values	Missing
`sea_level` has 2256 (100.0%) missing values	Missing
`grnd_level` has 2256 (100.0%) missing values	Missing
`humidity` has 504 (22.3%) missing values	Missing
`wind_speed` has 504 (22.3%) missing values	Missing
`rain_1h` has 2050 (90.9%) missing values	Missing
`clouds_all` has 504 (22.3%) missing values	Missing
`weather_description` has 504 (22.3%) missing values	Missing
`dt` is uniformly distributed	Uniform
`DataHora` has unique values	Unique
`sea_level` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`grnd_level` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Hora` has 94 (4.2%) zeros	Zeros
`Normal (kWh)` has 1225 (54.3%) zeros	Zeros
`Horário Económico (kWh)` has 1317 (58.4%) zeros	Zeros
`Autoconsumo (kWh)` has 1263 (56.0%) zeros	Zeros
`clouds_all` has 504 (22.3%) zeros	Zeros

Reproduction

Analysis started	2025-11-02 21:13:31.528028
Analysis finished	2025-11-02 21:14:08.177513
Duration	36.65 seconds
Software version	ydata-profiling vv4.17.0
Download configuration	config.json

DataHora
Date

Unique

Distinct	2256
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	17.8 KiB

Minimum	2023-01-01 00:00:00
Maximum	2023-04-04 23:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Data
Date

Distinct	94
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Memory size	17.8 KiB

Minimum	2023-01-01 00:00:00
Maximum	2023-04-04 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Hora
Real number (ℝ)

High correlation Zeros

Distinct	24
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.5

Minimum	0
Maximum	23
Zeros	94
Zeros (%)	4.2%
Negative	0
Negative (%)	0.0%
Memory size	17.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	5.75
median	11.5
Q3	17.25
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	11.5

Descriptive statistics

Standard deviation	6.9237212
Coefficient of variation (CV)	0.60206272
Kurtosis	-1.2041827
Mean	11.5
Median Absolute Deviation (MAD)	6
Skewness	0
Sum	25944
Variance	47.937916
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
0	94	4.2%
1	94	4.2%
2	94	4.2%
3	94	4.2%
4	94	4.2%
5	94	4.2%
6	94	4.2%
7	94	4.2%
8	94	4.2%
9	94	4.2%
Other values (14)	1316	58.3%

Value	Count	Frequency (%)
0	94	4.2%
1	94	4.2%
2	94	4.2%
3	94	4.2%
4	94	4.2%
5	94	4.2%
6	94	4.2%
7	94	4.2%
8	94	4.2%
9	94	4.2%

Value	Count	Frequency (%)
23	94	4.2%
22	94	4.2%
21	94	4.2%
20	94	4.2%
19	94	4.2%
18	94	4.2%
17	94	4.2%
16	94	4.2%
15	94	4.2%
14	94	4.2%

Normal (kWh)
Real number (ℝ)

High correlation Zeros

Distinct	709
Distinct (%)	31.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.26805984

Minimum	0
Maximum	3.381
Zeros	1225
Zeros (%)	54.3%
Negative	0
Negative (%)	0.0%
Memory size	17.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.39875
95-th percentile	1.27225
Maximum	3.381
Range	3.381
Interquartile range (IQR)	0.39875

Descriptive statistics

Standard deviation	0.46432336
Coefficient of variation (CV)	1.7321631
Kurtosis	7.1225225
Mean	0.26805984
Median Absolute Deviation (MAD)	0
Skewness	2.4579907
Sum	604.743
Variance	0.21559618
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1225	54.3%
0.222	7	0.3%
0.007	6	0.3%
0.507	5	0.2%
0.139	5	0.2%
0.338	5	0.2%
0.431	5	0.2%
0.637	5	0.2%
0.564	5	0.2%
0.287	4	0.2%
Other values (699)	984	43.6%

Value	Count	Frequency (%)
0	1225	54.3%
0.001	1	< 0.1%
0.002	1	< 0.1%
0.003	1	< 0.1%
0.004	1	< 0.1%
0.005	1	< 0.1%
0.006	3	0.1%
0.007	6	0.3%
0.009	4	0.2%
0.01	4	0.2%

Value	Count	Frequency (%)
3.381	1	< 0.1%
2.948	1	< 0.1%
2.845	1	< 0.1%
2.782	1	< 0.1%
2.77	1	< 0.1%
2.764	1	< 0.1%
2.651	1	< 0.1%
2.596	1	< 0.1%
2.533	1	< 0.1%
2.506	1	< 0.1%

Horário Económico (kWh)
Real number (ℝ)

High correlation Zeros

Distinct	490
Distinct (%)	21.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.22680895

Minimum	0
Maximum	2.771
Zeros	1317
Zeros (%)	58.4%
Negative	0
Negative (%)	0.0%
Memory size	17.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.336
95-th percentile	0.97675
Maximum	2.771
Range	2.771
Interquartile range (IQR)	0.336

Descriptive statistics

Standard deviation	0.37575217
Coefficient of variation (CV)	1.6566902
Kurtosis	9.2471322
Mean	0.22680895
Median Absolute Deviation (MAD)	0
Skewness	2.6471707
Sum	511.681
Variance	0.14118969
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1317	58.4%
0.244	10	0.4%
0.246	9	0.4%
0.305	9	0.4%
0.254	8	0.4%
0.306	8	0.4%
0.256	8	0.4%
0.251	7	0.3%
0.3	7	0.3%
0.297	7	0.3%
Other values (480)	866	38.4%

Value	Count	Frequency (%)
0	1317	58.4%
0.053	1	< 0.1%
0.145	1	< 0.1%
0.209	1	< 0.1%
0.223	1	< 0.1%
0.224	1	< 0.1%
0.229	1	< 0.1%
0.233	2	0.1%
0.234	3	0.1%
0.235	3	0.1%

Value	Count	Frequency (%)
2.771	1	< 0.1%
2.7	1	< 0.1%
2.672	1	< 0.1%
2.527	1	< 0.1%
2.499	1	< 0.1%
2.478	1	< 0.1%
2.472	1	< 0.1%
2.468	1	< 0.1%
2.215	1	< 0.1%
2.207	1	< 0.1%

Autoconsumo (kWh)
Real number (ℝ)

High correlation Zeros

Distinct	485
Distinct (%)	21.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.11943883

Minimum	0
Maximum	1.161
Zeros	1263
Zeros (%)	56.0%
Negative	0
Negative (%)	0.0%
Memory size	17.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.23725
95-th percentile	0.50525
Maximum	1.161
Range	1.161
Interquartile range (IQR)	0.23725

Descriptive statistics

Standard deviation	0.19060084
Coefficient of variation (CV)	1.595803
Kurtosis	3.7519876
Mean	0.11943883
Median Absolute Deviation (MAD)	0
Skewness	1.880032
Sum	269.454
Variance	0.036328681
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1263	56.0%
0.001	13	0.6%
0.003	11	0.5%
0.004	8	0.4%
0.002	8	0.4%
0.251	7	0.3%
0.255	6	0.3%
0.241	6	0.3%
0.007	6	0.3%
0.305	6	0.3%
Other values (475)	922	40.9%

Value	Count	Frequency (%)
0	1263	56.0%
0.001	13	0.6%
0.002	8	0.4%
0.003	11	0.5%
0.004	8	0.4%
0.005	6	0.3%
0.006	5	0.2%
0.007	6	0.3%
0.008	4	0.2%
0.009	3	0.1%

Value	Count	Frequency (%)
1.161	1	< 0.1%
1.07	1	< 0.1%
1.06	1	< 0.1%
0.995	2	0.1%
0.981	1	< 0.1%
0.976	1	< 0.1%
0.962	1	< 0.1%
0.954	1	< 0.1%
0.952	1	< 0.1%
0.915	1	< 0.1%

dt
Real number (ℝ)

Missing Uniform

Distinct	1752
Distinct (%)	100.0%
Missing	504
Missing (%)	22.3%
Infinite	0
Infinite (%)	0.0%
Mean	1.675683 × 10⁹

Minimum	1.6725312 × 10⁹
Maximum	1.6788348 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	17.8 KiB

Quantile statistics

Minimum	1.6725312 × 10⁹
5-th percentile	1.6728464 × 10⁹
Q1	1.6741071 × 10⁹
median	1.675683 × 10⁹
Q3	1.6772589 × 10⁹
95-th percentile	1.6785196 × 10⁹
Maximum	1.6788348 × 10⁹
Range	6303600
Interquartile range (IQR)	3151800

Descriptive statistics

Standard deviation	1821251.4
Coefficient of variation (CV)	0.0010868711
Kurtosis	-1.2
Mean	1.675683 × 10⁹
Median Absolute Deviation (MAD)	1576800
Skewness	-1.9848613 × 10^-16
Sum	2.9357966 × 10¹²
Variance	3.3169565 × 10¹²
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1672570800	1	< 0.1%
1672574400	1	< 0.1%
1672578000	1	< 0.1%
1672581600	1	< 0.1%
1672585200	1	< 0.1%
1672588800	1	< 0.1%
1672592400	1	< 0.1%
1672596000	1	< 0.1%
1672599600	1	< 0.1%
1672603200	1	< 0.1%
Other values (1742)	1742	77.2%
(Missing)	504	22.3%

Value	Count	Frequency (%)
1672531200	1	< 0.1%
1672534800	1	< 0.1%
1672538400	1	< 0.1%
1672542000	1	< 0.1%
1672545600	1	< 0.1%
1672549200	1	< 0.1%
1672552800	1	< 0.1%
1672556400	1	< 0.1%
1672560000	1	< 0.1%
1672563600	1	< 0.1%

Value	Count	Frequency (%)
1678834800	1	< 0.1%
1678831200	1	< 0.1%
1678827600	1	< 0.1%
1678824000	1	< 0.1%
1678820400	1	< 0.1%
1678816800	1	< 0.1%
1678813200	1	< 0.1%
1678809600	1	< 0.1%
1678806000	1	< 0.1%
1678802400	1	< 0.1%

dt_iso
Text

Missing

Distinct	1752
Distinct (%)	100.0%
Missing	504
Missing (%)	22.3%
Memory size	149.3 KiB

Length

Max length	29
Median length	29
Mean length	29
Min length	29

Characters and Unicode

Total characters	50808
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1752 ?
Unique (%)	100.0%

Sample

1st row	2023-01-01 00:00:00 +0000 UTC
2nd row	2023-01-01 01:00:00 +0000 UTC
3rd row	2023-01-01 02:00:00 +0000 UTC
4th row	2023-01-01 03:00:00 +0000 UTC
5th row	2023-01-01 04:00:00 +0000 UTC

Value	Count	Frequency (%)
0000	1752	25.0%
utc	1752	25.0%
11:00:00	73	1.0%
10:00:00	73	1.0%
12:00:00	73	1.0%
13:00:00	73	1.0%
14:00:00	73	1.0%
15:00:00	73	1.0%
16:00:00	73	1.0%
17:00:00	73	1.0%
Other values (89)	2920	41.7%

Most occurring characters

Value	Count	Frequency (%)
0	19261	37.9%
2	5335	10.5%
	5256	10.3%
:	3504	6.9%
-	3504	6.9%
3	2547	5.0%
1	2509	4.9%
+	1752	3.4%
U	1752	3.4%
T	1752	3.4%
Other values (7)	3636	7.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	50808	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	19261	37.9%
2	5335	10.5%
	5256	10.3%
:	3504	6.9%
-	3504	6.9%
3	2547	5.0%
1	2509	4.9%
+	1752	3.4%
U	1752	3.4%
T	1752	3.4%
Other values (7)	3636	7.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	50808	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	19261	37.9%
2	5335	10.5%
	5256	10.3%
:	3504	6.9%
-	3504	6.9%
3	2547	5.0%
1	2509	4.9%
+	1752	3.4%
U	1752	3.4%
T	1752	3.4%
Other values (7)	3636	7.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	50808	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	19261	37.9%
2	5335	10.5%
	5256	10.3%
:	3504	6.9%
-	3504	6.9%
3	2547	5.0%
1	2509	4.9%
+	1752	3.4%
U	1752	3.4%
T	1752	3.4%
Other values (7)	3636	7.2%

city_name
Categorical

Constant Missing

Distinct	1
Distinct (%)	0.1%
Missing	504
Missing (%)	22.3%
Memory size	120.1 KiB

local	1752

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	8760
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	local
2nd row	local
3rd row	local
4th row	local
5th row	local

Common Values

Value	Count	Frequency (%)
local	1752	77.7%
(Missing)	504	22.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
local	1752	100.0%

Most occurring characters

Value	Count	Frequency (%)
l	3504	40.0%
o	1752	20.0%
c	1752	20.0%
a	1752	20.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8760	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	3504	40.0%
o	1752	20.0%
c	1752	20.0%
a	1752	20.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8760	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	3504	40.0%
o	1752	20.0%
c	1752	20.0%
a	1752	20.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8760	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	3504	40.0%
o	1752	20.0%
c	1752	20.0%
a	1752	20.0%

temp
Real number (ℝ)

High correlation Missing

Distinct	889
Distinct (%)	50.7%
Missing	504
Missing (%)	22.3%
Infinite	0
Infinite (%)	0.0%
Mean	10.599606

Minimum	0.93
Maximum	20.61
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	17.8 KiB

Quantile statistics

Minimum	0.93
5-th percentile	4.1955
Q1	7.8775
median	10.95
Q3	13.2925
95-th percentile	16.39
Maximum	20.61
Range	19.68
Interquartile range (IQR)	5.415

Descriptive statistics

Standard deviation	3.7151563
Coefficient of variation (CV)	0.35049947
Kurtosis	-0.43883227
Mean	10.599606
Median Absolute Deviation (MAD)	2.6
Skewness	-0.11427813
Sum	18570.51
Variance	13.802386
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12.98	18	0.8%
13.49	16	0.7%
14.59	14	0.6%
12.91	12	0.5%
12.4	11	0.5%
11.29	10	0.4%
12.38	9	0.4%
13.55	9	0.4%
11.9	8	0.4%
13.01	8	0.4%
Other values (879)	1637	72.6%
(Missing)	504	22.3%

Value	Count	Frequency (%)
0.93	1	< 0.1%
1.04	1	< 0.1%
1.12	1	< 0.1%
1.22	1	< 0.1%
1.78	1	< 0.1%
1.81	1	< 0.1%
1.98	1	< 0.1%
2.26	1	< 0.1%
2.27	1	< 0.1%
2.29	1	< 0.1%

Value	Count	Frequency (%)
20.61	1	< 0.1%
20.47	1	< 0.1%
20.45	1	< 0.1%
20.3	1	< 0.1%
20.25	1	< 0.1%
20.21	1	< 0.1%
19.96	2	0.1%
19.72	1	< 0.1%
19.7	2	0.1%
19.57	1	< 0.1%

feels_like
Real number (ℝ)

High correlation Missing

Distinct	1007
Distinct (%)	57.5%
Missing	504
Missing (%)	22.3%
Infinite	0
Infinite (%)	0.0%
Mean	9.5432648

Minimum	-1.79
Maximum	19.79
Zeros	0
Zeros (%)	0.0%
Negative	12
Negative (%)	0.5%
Memory size	17.8 KiB

Quantile statistics

Minimum	-1.79
5-th percentile	2.3255
Q1	6.2175
median	10.135
Q3	12.7425
95-th percentile	15.609
Maximum	19.79
Range	21.58
Interquartile range (IQR)	6.525

Descriptive statistics

Standard deviation	4.1912244
Coefficient of variation (CV)	0.4391814
Kurtosis	-0.60687299
Mean	9.5432648
Median Absolute Deviation (MAD)	3.09
Skewness	-0.25248791
Sum	16719.8
Variance	17.566362
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13.36	8	0.4%
11.77	8	0.4%
10.93	8	0.4%
12.79	8	0.4%
15.11	7	0.3%
9.58	7	0.3%
12.85	7	0.3%
10.27	7	0.3%
12.2	7	0.3%
12.18	7	0.3%
Other values (997)	1678	74.4%
(Missing)	504	22.3%

Value	Count	Frequency (%)
-1.79	1	< 0.1%
-1.75	1	< 0.1%
-1.49	1	< 0.1%
-0.87	1	< 0.1%
-0.73	1	< 0.1%
-0.57	1	< 0.1%
-0.24	1	< 0.1%
-0.22	1	< 0.1%
-0.11	2	0.1%
-0.09	1	< 0.1%

Value	Count	Frequency (%)
19.79	1	< 0.1%
19.7	1	< 0.1%
19.51	1	< 0.1%
19.48	1	< 0.1%
19.33	1	< 0.1%
19.25	1	< 0.1%
19.21	1	< 0.1%
19.2	1	< 0.1%
19.03	1	< 0.1%
18.92	1	< 0.1%

temp_min
Real number (ℝ)

High correlation Missing

Distinct	169
Distinct (%)	9.6%
Missing	504
Missing (%)	22.3%
Infinite	0
Infinite (%)	0.0%
Mean	9.1779167

Minimum	-0.85
Maximum	20.01
Zeros	0
Zeros (%)	0.0%
Negative	13
Negative (%)	0.6%
Memory size	17.8 KiB

Quantile statistics

Minimum	-0.85
5-th percentile	1.963
Q1	6.2475
median	9.71
Q3	12.32
95-th percentile	14.72
Maximum	20.01
Range	20.86
Interquartile range (IQR)	6.0725

Descriptive statistics

Standard deviation	4.0211764
Coefficient of variation (CV)	0.43813608
Kurtosis	-0.60244543
Mean	9.1779167
Median Absolute Deviation (MAD)	3.01
Skewness	-0.28607629
Sum	16079.71
Variance	16.16986
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12.79	41	1.8%
12.23	38	1.7%
10.66	36	1.6%
13.43	34	1.5%
9.54	33	1.5%
9.23	32	1.4%
7.57	32	1.4%
12.72	31	1.4%
4.71	28	1.2%
11.21	28	1.2%
Other values (159)	1419	62.9%
(Missing)	504	22.3%

Value	Count	Frequency (%)
-0.85	3	0.1%
-0.29	8	0.4%
-0.28	1	< 0.1%
-0.21	1	< 0.1%
0.26	6	0.3%
0.34	2	0.1%
0.72	10	0.4%
0.82	9	0.4%
0.9	10	0.4%
1.38	8	0.4%

Value	Count	Frequency (%)
20.01	1	< 0.1%
19.45	1	< 0.1%
18.9	1	< 0.1%
18.72	2	0.1%
18.6	1	< 0.1%
18.34	2	0.1%
17.79	2	0.1%
17.72	6	0.3%
17.37	1	< 0.1%
17.32	4	0.2%

temp_max
Real number (ℝ)

High correlation Missing

Distinct	174
Distinct (%)	9.9%
Missing	504
Missing (%)	22.3%
Infinite	0
Infinite (%)	0.0%
Mean	11.643813

Minimum	3.34
Maximum	22.01
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	17.8 KiB

Quantile statistics

Minimum	3.34
5-th percentile	5.66
Q1	8.9
median	11.82
Q3	14.04
95-th percentile	17.01
Maximum	22.01
Range	18.67
Interquartile range (IQR)	5.14

Descriptive statistics

Standard deviation	3.5968823
Coefficient of variation (CV)	0.30890932
Kurtosis	-0.3703718
Mean	11.643813
Median Absolute Deviation (MAD)	2.72
Skewness	-0.01743194
Sum	20399.96
Variance	12.937563
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13.82	95	4.2%
11.82	74	3.3%
12.82	72	3.2%
10.82	49	2.2%
14.82	44	2.0%
15.82	34	1.5%
6.82	29	1.3%
9.82	26	1.2%
13.72	26	1.2%
8.82	26	1.2%
Other values (164)	1277	56.6%
(Missing)	504	22.3%

Value	Count	Frequency (%)
3.34	1	< 0.1%
3.43	2	0.1%
3.72	1	< 0.1%
3.9	2	0.1%
3.99	6	0.3%
4.04	2	0.1%
4.23	1	< 0.1%
4.45	9	0.4%
4.54	10	0.4%
4.59	4	0.2%

Value	Count	Frequency (%)
22.01	2	0.1%
21.82	1	< 0.1%
21.45	2	0.1%
21.38	2	0.1%
21.12	1	< 0.1%
20.9	2	0.1%
20.82	3	0.1%
20.7	2	0.1%
20.34	5	0.2%
20.26	3	0.1%

pressure
Real number (ℝ)

Missing

Distinct	31
Distinct (%)	1.8%
Missing	504
Missing (%)	22.3%
Infinite	0
Infinite (%)	0.0%
Mean	1023.4937

Minimum	1006
Maximum	1036
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	17.8 KiB

Quantile statistics

Minimum	1006
5-th percentile	1010
Q1	1020
median	1024
Q3	1029
95-th percentile	1033
Maximum	1036
Range	30
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	6.6508731
Coefficient of variation (CV)	0.006498206
Kurtosis	-0.38232493
Mean	1023.4937
Median Absolute Deviation (MAD)	4
Skewness	-0.60862297
Sum	1793161
Variance	44.234112
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
1028	142	6.3%
1030	117	5.2%
1024	112	5.0%
1027	111	4.9%
1029	110	4.9%
1021	100	4.4%
1023	95	4.2%
1026	88	3.9%
1025	81	3.6%
1020	75	3.3%
Other values (21)	721	32.0%
(Missing)	504	22.3%

Value	Count	Frequency (%)
1006	3	0.1%
1007	6	0.3%
1008	24	1.1%
1009	27	1.2%
1010	38	1.7%
1011	31	1.4%
1012	42	1.9%
1013	32	1.4%
1014	29	1.3%
1015	28	1.2%

Value	Count	Frequency (%)
1036	3	0.1%
1035	8	0.4%
1034	27	1.2%
1033	61	2.7%
1032	61	2.7%
1031	58	2.6%
1030	117	5.2%
1029	110	4.9%
1028	142	6.3%
1027	111	4.9%

sea_level
Unsupported

Missing Rejected Unsupported

Missing	2256
Missing (%)	100.0%
Memory size	17.8 KiB

grnd_level
Unsupported

Missing Rejected Unsupported

Missing	2256
Missing (%)	100.0%
Memory size	17.8 KiB

humidity
Real number (ℝ)

High correlation Missing

Distinct	71
Distinct (%)	4.1%
Missing	504
Missing (%)	22.3%
Infinite	0
Infinite (%)	0.0%
Mean	75.63984

Minimum	23
Maximum	97
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	17.8 KiB

Quantile statistics

Minimum	23
5-th percentile	43
Q1	62
median	81
Q3	91
95-th percentile	95
Maximum	97
Range	74
Interquartile range (IQR)	29

Descriptive statistics

Standard deviation	17.415468
Coefficient of variation (CV)	0.230242
Kurtosis	-0.70029446
Mean	75.63984
Median Absolute Deviation (MAD)	13
Skewness	-0.65459207
Sum	132521
Variance	303.29854
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
94	143	6.3%
95	103	4.6%
93	76	3.4%
96	65	2.9%
85	49	2.2%
86	48	2.1%
92	47	2.1%
84	47	2.1%
91	47	2.1%
90	43	1.9%
Other values (61)	1084	48.0%
(Missing)	504	22.3%

Value	Count	Frequency (%)
23	1	< 0.1%
25	2	0.1%
26	2	0.1%
30	1	< 0.1%
31	2	0.1%
32	3	0.1%
33	1	< 0.1%
34	2	0.1%
35	5	0.2%
36	9	0.4%

Value	Count	Frequency (%)
97	2	0.1%
96	65	2.9%
95	103	4.6%
94	143	6.3%
93	76	3.4%
92	47	2.1%
91	47	2.1%
90	43	1.9%
89	42	1.9%
88	32	1.4%

wind_speed
Real number (ℝ)

Missing

Distinct	512
Distinct (%)	29.2%
Missing	504
Missing (%)	22.3%
Infinite	0
Infinite (%)	0.0%
Mean	2.873613

Minimum	0.12
Maximum	10.32
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	17.8 KiB

Quantile statistics

Minimum	0.12
5-th percentile	1.02
Q1	1.8
median	2.49
Q3	3.5
95-th percentile	6.507
Maximum	10.32
Range	10.2
Interquartile range (IQR)	1.7

Descriptive statistics

Standard deviation	1.6204501
Coefficient of variation (CV)	0.56390685
Kurtosis	2.5172904
Mean	2.873613
Median Absolute Deviation (MAD)	0.78
Skewness	1.4667235
Sum	5034.57
Variance	2.6258584
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.8	13	0.6%
2.87	13	0.6%
1.87	13	0.6%
1.96	13	0.6%
2.48	12	0.5%
1.73	12	0.5%
1.79	12	0.5%
1.86	11	0.5%
2.2	11	0.5%
2.83	11	0.5%
Other values (502)	1631	72.3%
(Missing)	504	22.3%

Value	Count	Frequency (%)
0.12	1	< 0.1%
0.16	1	< 0.1%
0.22	1	< 0.1%
0.31	2	0.1%
0.34	1	< 0.1%
0.35	1	< 0.1%
0.37	1	< 0.1%
0.39	2	0.1%
0.42	1	< 0.1%
0.44	1	< 0.1%

Value	Count	Frequency (%)
10.32	1	< 0.1%
9.87	1	< 0.1%
9.56	1	< 0.1%
9.53	1	< 0.1%
9.48	1	< 0.1%
9.38	1	< 0.1%
9.34	1	< 0.1%
9.25	1	< 0.1%
9.17	1	< 0.1%
9.12	1	< 0.1%

rain_1h
Real number (ℝ)

High correlation Missing

Distinct	120
Distinct (%)	58.3%
Missing	2050
Missing (%)	90.9%
Infinite	0
Infinite (%)	0.0%
Mean	1.0250971

Minimum	0.11
Maximum	6.38
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	17.8 KiB

Quantile statistics

Minimum	0.11
5-th percentile	0.13
Q1	0.25
median	0.565
Q3	1.245
95-th percentile	3.63
Maximum	6.38
Range	6.27
Interquartile range (IQR)	0.995

Descriptive statistics

Standard deviation	1.2096175
Coefficient of variation (CV)	1.1800028
Kurtosis	5.2551679
Mean	1.0250971
Median Absolute Deviation (MAD)	0.395
Skewness	2.2058189
Sum	211.17
Variance	1.4631744
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.15	7	0.3%
0.13	6	0.3%
0.11	5	0.2%
0.22	5	0.2%
0.19	4	0.2%
0.12	4	0.2%
0.31	4	0.2%
0.14	4	0.2%
0.57	4	0.2%
0.33	4	0.2%
Other values (110)	159	7.0%
(Missing)	2050	90.9%

Value	Count	Frequency (%)
0.11	5	0.2%
0.12	4	0.2%
0.13	6	0.3%
0.14	4	0.2%
0.15	7	0.3%
0.16	2	0.1%
0.17	2	0.1%
0.18	2	0.1%
0.19	4	0.2%
0.2	3	0.1%

Value	Count	Frequency (%)
6.38	1	< 0.1%
6.16	1	< 0.1%
6.11	1	< 0.1%
5.42	1	< 0.1%
4.96	1	< 0.1%
4.48	1	< 0.1%
4.07	1	< 0.1%
3.86	1	< 0.1%
3.79	1	< 0.1%
3.76	1	< 0.1%

clouds_all
Real number (ℝ)

High correlation Missing Zeros

Distinct	99
Distinct (%)	5.7%
Missing	504
Missing (%)	22.3%
Infinite	0
Infinite (%)	0.0%
Mean	44.489726

Minimum	0
Maximum	100
Zeros	504
Zeros (%)	22.3%
Negative	0
Negative (%)	0.0%
Memory size	17.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	35
Q3	96
95-th percentile	100
Maximum	100
Range	100
Interquartile range (IQR)	96

Descriptive statistics

Standard deviation	42.972438
Coefficient of variation (CV)	0.96589576
Kurtosis	-1.7393436
Mean	44.489726
Median Absolute Deviation (MAD)	35
Skewness	0.20532117
Sum	77946
Variance	1846.6304
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	504	22.3%
100	335	14.8%
99	48	2.1%
1	45	2.0%
2	37	1.6%
5	36	1.6%
4	35	1.6%
3	33	1.5%
98	30	1.3%
96	23	1.0%
Other values (89)	626	27.7%
(Missing)	504	22.3%

Value	Count	Frequency (%)
0	504	22.3%
1	45	2.0%
2	37	1.6%
3	33	1.5%
4	35	1.6%
5	36	1.6%
6	17	0.8%
7	12	0.5%
8	12	0.5%
9	15	0.7%

Value	Count	Frequency (%)
100	335	14.8%
99	48	2.1%
98	30	1.3%
97	22	1.0%
96	23	1.0%
95	10	0.4%
94	13	0.6%
93	13	0.6%
92	13	0.6%
91	9	0.4%

weather_description
Categorical

High correlation Missing

Distinct	8
Distinct (%)	0.5%
Missing	504
Missing (%)	22.3%
Memory size	133.0 KiB

sky is clear	739
overcast clouds	305
light rain	299
broken clouds	149
scattered clouds	118
Other values (3)	142

Length

Max length	20
Median length	16
Mean length	12.524543
Min length	10

Characters and Unicode

Total characters	21943
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	moderate rain
2nd row	moderate rain
3rd row	moderate rain
4th row	moderate rain
5th row	moderate rain

Common Values

Value	Count	Frequency (%)
sky is clear	739	32.8%
overcast clouds	305	13.5%
light rain	299	13.3%
broken clouds	149	6.6%
scattered clouds	118	5.2%
few clouds	70	3.1%
moderate rain	65	2.9%
heavy intensity rain	7	0.3%
(Missing)	504	22.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
sky	739	17.4%
is	739	17.4%
clear	739	17.4%
clouds	642	15.1%
rain	371	8.7%
overcast	305	7.2%
light	299	7.0%
broken	149	3.5%
scattered	118	2.8%
few	70	1.6%
Other values (3)	79	1.9%

Most occurring characters

Value	Count	Frequency (%)
s	2550	11.6%
	2498	11.4%
c	1804	8.2%
r	1747	8.0%
l	1680	7.7%
e	1643	7.5%
a	1605	7.3%
i	1423	6.5%
o	1161	5.3%
t	919	4.2%
Other values (12)	4913	22.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21943	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	2550	11.6%
	2498	11.4%
c	1804	8.2%
r	1747	8.0%
l	1680	7.7%
e	1643	7.5%
a	1605	7.3%
i	1423	6.5%
o	1161	5.3%
t	919	4.2%
Other values (12)	4913	22.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21943	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	2550	11.6%
	2498	11.4%
c	1804	8.2%
r	1747	8.0%
l	1680	7.7%
e	1643	7.5%
a	1605	7.3%
i	1423	6.5%
o	1161	5.3%
t	919	4.2%
Other values (12)	4913	22.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21943	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	2550	11.6%
	2498	11.4%
c	1804	8.2%
r	1747	8.0%
l	1680	7.7%
e	1643	7.5%
a	1605	7.3%
i	1423	6.5%
o	1161	5.3%
t	919	4.2%
Other values (12)	4913	22.4%

Interactions

Correlations

	Autoconsumo (kWh)	Hora	Horário Económico (kWh)	Normal (kWh)	clouds_all	dt	feels_like	humidity	pressure	rain_1h	temp	temp_max	temp_min	weather_description	wind_speed
Autoconsumo (kWh)	1.000	0.095	-0.621	0.198	-0.108	0.083	0.302	-0.364	0.054	-0.092	0.344	0.336	0.310	0.085	0.065
Hora	0.095	1.000	-0.414	0.518	-0.047	0.014	0.246	-0.196	-0.013	-0.143	0.262	0.283	0.275	0.000	-0.043
Horário Económico (kWh)	-0.621	-0.414	1.000	-0.696	0.008	0.009	-0.352	0.259	-0.003	-0.020	-0.384	-0.382	-0.382	0.000	-0.051
Normal (kWh)	0.198	0.518	-0.696	1.000	0.072	-0.016	0.237	-0.092	-0.079	-0.068	0.250	0.258	0.276	0.034	0.040
clouds_all	-0.108	-0.047	0.008	0.072	1.000	-0.015	0.343	0.611	-0.425	0.449	0.285	0.253	0.336	0.670	0.223
dt	0.083	0.014	0.009	-0.016	-0.015	1.000	0.181	-0.232	-0.433	-0.319	0.179	0.172	0.190	0.309	-0.020
feels_like	0.302	0.246	-0.352	0.237	0.343	0.181	1.000	-0.020	-0.155	0.316	0.989	0.954	0.962	0.162	0.168
humidity	-0.364	-0.196	0.259	-0.092	0.611	-0.232	-0.020	1.000	-0.255	0.291	-0.103	-0.114	-0.022	0.270	0.209
pressure	0.054	-0.013	-0.003	-0.079	-0.425	-0.433	-0.155	-0.255	1.000	-0.443	-0.131	-0.123	-0.195	0.247	-0.271
rain_1h	-0.092	-0.143	-0.020	-0.068	0.449	-0.319	0.316	0.291	-0.443	1.000	0.320	0.297	0.358	0.919	0.436
temp	0.344	0.262	-0.384	0.250	0.285	0.179	0.989	-0.103	-0.131	0.320	1.000	0.970	0.967	0.150	0.201
temp_max	0.336	0.283	-0.382	0.258	0.253	0.172	0.954	-0.114	-0.123	0.297	0.970	1.000	0.947	0.161	0.218
temp_min	0.310	0.275	-0.382	0.276	0.336	0.190	0.962	-0.022	-0.195	0.358	0.967	0.947	1.000	0.164	0.223
weather_description	0.085	0.000	0.000	0.034	0.670	0.309	0.162	0.270	0.247	0.919	0.150	0.161	0.164	1.000	0.269
wind_speed	0.065	-0.043	-0.051	0.040	0.223	-0.020	0.168	0.209	-0.271	0.436	0.201	0.218	0.223	0.269	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	DataHora	Data	Hora	Normal (kWh)	Horário Económico (kWh)	Autoconsumo (kWh)	dt	dt_iso	city_name	temp	feels_like	temp_min	temp_max	pressure	sea_level	grnd_level	humidity	wind_speed	rain_1h	clouds_all	weather_description
0	2023-01-01 00:00:00	2023-01-01	0	0.000	0.467	0.000	1.672531e+09	2023-01-01 00:00:00 +0000 UTC	local	12.93	12.76	12.72	13.43	1019.0	NaN	NaN	95.0	2.02	3.72	100.0	moderate rain
1	2023-01-01 01:00:00	2023-01-01	1	0.000	0.577	0.000	1.672535e+09	2023-01-01 01:00:00 +0000 UTC	local	13.49	13.38	13.43	13.90	1018.0	NaN	NaN	95.0	2.18	3.26	100.0	moderate rain
2	2023-01-01 02:00:00	2023-01-01	2	0.000	0.346	0.000	1.672538e+09	2023-01-01 02:00:00 +0000 UTC	local	13.55	13.44	13.48	14.82	1017.0	NaN	NaN	95.0	2.88	2.44	100.0	moderate rain
3	2023-01-01 03:00:00	2023-01-01	3	0.000	0.270	0.000	1.672542e+09	2023-01-01 03:00:00 +0000 UTC	local	13.61	13.51	12.01	14.82	1016.0	NaN	NaN	95.0	3.63	1.74	100.0	moderate rain
4	2023-01-01 04:00:00	2023-01-01	4	0.000	0.252	0.000	1.672546e+09	2023-01-01 04:00:00 +0000 UTC	local	13.59	13.49	12.01	14.82	1015.0	NaN	NaN	95.0	4.58	1.13	100.0	moderate rain
5	2023-01-01 05:00:00	2023-01-01	5	0.000	0.255	0.000	1.672549e+09	2023-01-01 05:00:00 +0000 UTC	local	13.70	13.61	13.12	15.82	1014.0	NaN	NaN	95.0	6.36	1.23	99.0	moderate rain
6	2023-01-01 06:00:00	2023-01-01	6	0.000	0.256	0.000	1.672553e+09	2023-01-01 06:00:00 +0000 UTC	local	14.22	14.18	14.04	16.12	1014.0	NaN	NaN	95.0	8.55	1.20	100.0	moderate rain
7	2023-01-01 07:00:00	2023-01-01	7	0.000	0.263	0.000	1.672556e+09	2023-01-01 07:00:00 +0000 UTC	local	15.30	15.31	14.79	16.82	1015.0	NaN	NaN	93.0	8.37	2.20	100.0	moderate rain
8	2023-01-01 08:00:00	2023-01-01	8	0.275	0.000	0.002	1.672560e+09	2023-01-01 08:00:00 +0000 UTC	local	16.80	16.55	15.66	16.82	1015.0	NaN	NaN	77.0	8.29	2.20	100.0	moderate rain
9	2023-01-01 09:00:00	2023-01-01	9	0.331	0.000	0.000	1.672564e+09	2023-01-01 09:00:00 +0000 UTC	local	16.61	16.31	14.72	16.82	1014.0	NaN	NaN	76.0	8.38	2.13	100.0	moderate rain

	DataHora	Data	Hora	Normal (kWh)	Horário Económico (kWh)	Autoconsumo (kWh)	dt	dt_iso	city_name	temp	feels_like	temp_min	temp_max	pressure	sea_level	grnd_level	humidity	wind_speed	rain_1h	clouds_all	weather_description
2246	2023-04-04 14:00:00	2023-04-04	14	0.000	0.000	0.321	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
2247	2023-04-04 15:00:00	2023-04-04	15	0.000	0.000	0.319	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
2248	2023-04-04 16:00:00	2023-04-04	16	0.000	0.000	0.307	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
2249	2023-04-04 17:00:00	2023-04-04	17	0.000	0.000	0.330	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
2250	2023-04-04 18:00:00	2023-04-04	18	0.207	0.000	0.137	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
2251	2023-04-04 19:00:00	2023-04-04	19	0.953	0.000	0.012	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
2252	2023-04-04 20:00:00	2023-04-04	20	0.915	0.000	0.000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
2253	2023-04-04 21:00:00	2023-04-04	21	0.479	0.000	0.000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
2254	2023-04-04 22:00:00	2023-04-04	22	0.000	0.497	0.000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
2255	2023-04-04 23:00:00	2023-04-04	23	0.000	0.487	0.000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample